AfterColEdit Event

       

Occurs after editing is completed in a grid cell.

Syntax

Private Sub object_AfterColEdit([ index As Integer,] ByVal colindex As Integer)

The AfterColEdit event syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
Index An integer that identifies a control if it is in a control array.
colindex An integer that identifies the column that was edited.

Remarks

When the user completes editing within a grid cell, as when tabbing to another column in the same row, pressing the ENTER key, or clicking on another cell, the BeforeColUpdate and AfterColUpdate events are executed, and data from the cell is moved to the grid's copy buffer. The AfterColEdit event immediately follows the AfterColUpdate event.

When editing is completed in a grid cell, this event is always triggered, even if no changes were made to the cell or the BeforeColUpdate event was canceled.

The AfterColEdit event will not be fired if the BeforeColEdit event is canceled.